Example for correct escape sequence transformation (SELECT statement):



[25096-0.389]SC_recycle_statement: self= 01168FC0
[25096-0.390]PDATA_free_params:  ENTER, self=01169164
[25096-0.391]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=95, stmt='select * from egstat_dbins( 100, 125, {d '2009-10-04'}, '15:36:46', 2000, 'ipadresse', 6, 0, 0)'
[25096-0.395]   stmt_with_params = 'select * from egstat_dbins( 100, 125, '2009-10-04'::date , '15:36:46', 2000, 'ipadresse', 6, 0, 0)'
[25096-0.398]about to begin SC_execute
[25096-0.399]       Sending SELECT statement on stmt=01168FC0, cursor_name='SQL_CUR01168FC0' qflag=0,1
[25096-0.401]CC_send_query: conn=01163F68, query='select * from egstat_dbins( 100, 125, '2009-10-04'::date , '15:36:46', 2000, 'ipadresse', 6, 0, 0)'
[25096-0.407]send_query: done sending query 104bytes flushed


Example for wrong (missing) escape sequence transformation (CALL statement):



[22372-10.317]Exec_with_parameters_resolved: copying statement params: trans_status=1, len=88, stmt='{call egstat_dbins( 100, 125, {d '2009-10-12'}, '13:28:26', 2000, 'ipadresse', 6, 0, 0)}'
[22372-10.321]   stmt_with_params = 'SELECT * FROM egstat_dbins( 100, 125,  d '2009-10-12', '13:28:26', 2000, 'ipadresse', 6, 0, 0)'
[22372-10.323]about to begin SC_execute
[22372-10.324]      it's NOT a select statement: stmt=011620D0
[22372-10.326]CC_send_query: conn=01164F60, query='SELECT * FROM egstat_dbins( 100, 125,  d '2009-10-12', '13:28:26', 2000, 'ipadresse', 6, 0, 0)'
[22372-10.331]send_query: done sending query 100bytes flushed
[22372-10.332]in QR_Constructor
[22372-10.332]exit QR_Constructor
[22372-10.333]read -1, global_socket_buffersize=4096
[22372-10.334]Lasterror=10035
[22372-10.336]read 85, global_socket_buffersize=4096
[22372-10.337]send_query: got id = 'E'
[22372-10.338]send_query: 'E' - SFEHLER
[22372-10.340]send_query: 'E' - C42704
[22372-10.342]send_query: 'E' - MTyp »d« existiert nicht
[22372-10.345]send_query: 'E' - P40
[22372-10.346]send_query: 'E' - Fparse_type.c
[22372-10.349]send_query: 'E' - L200
[22372-10.351]send_query: 'E' - RtypenameType
[22372-10.353]read 6, global_socket_buffersize=4096
[22372-10.354]send_query: got id = 'Z'
[22372-10.355]SC_set_Result(11620d0, 1162a08)[22372-10.356]QResult: enter DESTRUCTOR
[22372-10.359]STATEMENT ERROR: func=SC_execute, desc='(null)', errnum=7, errmsg='Error while executing the query'
[22372-10.391]CONN ERROR: func=SC_execute, desc='(null)', errnum=110, errmsg='FEHLER: Typ »d« existiert nicht'